Computer Science for IGCSE & O level - Databases (Section 3 - No. 29)
What is the purpose of a WHERE clause in an SQL query?
To specify the table from which to retrieve data.
To sort the results of the query.
To filter the data based on specified conditions.
To group the results.
Forklaring
The WHERE clause is used to filter the retrieved data based on given conditions. It specifies which records should be included in the query's result set.